package asposefeatures.workingwithworksheets.addwordartwatermarktochart.java;
import com.aspose.cells.MsoPresetTextEffect;
import com.aspose.cells.SaveFormat;
import com.aspose.cells.Workbook;
public class AddWordArtWatermarkToChart
{
public static void main(String[] args) throws Exception
{
String dataPath = "src/asposefeatures/workingwithworksheets/addwordartwatermarktochart/data/";
//Instantiate a new workbook.
//Open the existing excel file.
Workbook workbook = new Workbook(dataPath + "AsposeChart.xls");
//Get the chart in the first worksheet.
com.aspose.cells.Chart chart = workbook.getWorksheets().get(0).getCharts().get(0);
//Add a WordArt watermark (shape) to the chart's plot area.
com.aspose.cells.Shape wordart = chart.getShapes().addTextEffectInChart(MsoPresetTextEffect.TEXT_EFFECT_2,
"CONFIDENTIAL", "Arial Black", 66, false, false, 1200, 500, 2000, 3000);
//Get the shape's fill format.
com.aspose.cells.MsoFillFormat wordArtFormat = wordart.getFillFormat();
//Set the transparency.
wordArtFormat.setTransparency(0.9);
//Get the line format and make it invisible.
com.aspose.cells.MsoLineFormat lineFormat = wordart.getLineFormat();
lineFormat.setVisible(false);
//Save the excel file.
workbook.save(dataPath + "AsposeChartWatermarked_Out.xls", SaveFormat.EXCEL_97_TO_2003);
System.out.println("Chart is watermarked now.");
}
}